<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta content="MSHTML 6.00.6000.17080" name="GENERATOR" />
<meta name="author" content="York.chow@actionsky.com" />
<link rel="SHORTCUT ICON" href="../../logo.ico" />
<link href="../../assets/ocom.css" type="text/css" rel="stylesheet" />
<link href="../../assets/master-master.css" type="text/css" rel="stylesheet" />
<script language="JavaScript" src="../../assets/actionlib.js"></script>
<script language="JavaScript" src="../../assets/prototype-1.6.0.2.js"></script>
<script>
  window.onresize=function(e){
	   	document.getElementById("panelDiva").style.left = 0 +"px";
     }
$(document).observe('dom:loaded', function() {
		$$('ul#navigation li').each(function(li){
			li.observe('mouseover', function(){
				li.addClassName('hover');
			});
			li.observe('mouseout', function(){
				li.removeClassName('hover');
			});
		});
	});
</script>
<title>MySQL性能测试</title>
<meta name="Title" content="MySQL5.4 -高达90 ％的快速查询响应时间和16路x86服务器和64路CMT服务器的可扩展性">
<meta name="Description" content="MySQL5.4 -高达90 ％的快速查询响应时间和16路x86服务器和64路CMT服务器的可扩展性">
<meta name="robots" content="INDEX, FOLLOW">

  <style type="text/css">
  .sitefinder_content {position:absolute;right:50%; margin-right:-495px; z-index:100002;overflow: auto; top:5px;}
  #Wrapper_FixedWidth { min-width:974px; }
  .header{height:140px; *height:130px;}
  </style>
</head>
<body>
<div id="Wrapper_FixedWidth">
    <div id="Wrapper_FixedWidth_Header">
	<!-- ****************************************************** -->
	<c:import url="../../template/header.jsp"></c:import>
	<!-- ****************************************************** -->
	<div id="breadCrumb">
	    <div class="breadCrumb_Left"></div>
	    <div class="breadCrumb_Center">

	    <div style="position:relative;">
	    <span class="breadCrumb_Content">
			    <a href="../../default.htm"><span class=red>爱可生</span></a>
			    <span class="rightarrow"><img src="../../assets/rightarrow-066625.gif" /></span>
			    <a href="../index.jsp">为什么选择MySQL</a>
			    <span class="rightarrow"><img src="../../assets/rightarrow-066625.gif" /></span>
			    <span class="active">性能测试</span>
	    </span>
	    </div>

	    </div>
	    <div class="breadCrumb_Right"></div>
	    </div>

			<!--SS_END_SNIPPET(fragment57,2)-->

      </div>
	</div>

    <div id="wrapper_lnav_maincont_rcol_foot">

      <div id="Wrapper_FixedWidth_Leftnav">
        

                
                <div class="topLeftNavBorder_li"><!--Spacer--></div> 
                <div class="XMLLeftNav_li" id="XMLLeftNav">

		
 
		<!--** section link: **-->    
		     
		    		   
 		<!-- ****************************************************** -->
		<c:import url="../../template/left.jsp">
			<c:param name="main" value="why-mysql"/>
			<c:param name="sub" value="benchmarks"/>
		</c:import>	
		<!-- ****************************************************** -->					
               								
 
     	        </div>
		<div class="botLeftNavBorder_li"><!--Spacer--></div>

											
	<!--** end of ExternalNavMultiV **-->



<script language="javascript" type="text/javascript">

var myDiv = document.getElementById( "XMLLeftNav" );
var inputArr = myDiv.getElementsByTagName( "a" );
for (var i = 0; i < inputArr.length; i++) 
{
    	if (inputArr[i].href == "http://www.actionsky.com/corporate/index.jsp")
	{
		inputArr[i].className += " hideactive";
	}
		
}

   
    </script>
      </div><!--Start of Center Content--><!--Contribution Region Starts Here -->
<div id="Wrapper_FixedWidth_Maincontent">
<table cellspacing="0" cellpadding="0" border="0" width="100%">
    <tbody>
        <tr>

            <td width="3">&nbsp;</td>
            <td valign="top">
            <table cellspacing="0" cellpadding="0" border="0" width="100%" style="margin-bottom: 17px;" padding="0">
            <tbody>
            	<tr><td><img src="../../assets/cnt/benchmarks.jpg"/></td></tr>
            </tbody>
            </table>
            
        <a name="top"></a>    <h1><span class="contents">性能测试</span></h1>
            <!-- End Page Header -->         <!-- Begin Anchor Link Section -->
            
            <table cellspacing="0" cellpadding="0" border="0" width="100%" padding="0" class="fifteenpxBotMargin">
             <tbody>               
             <tr>                  
             <td width="3" class="innerBoxHeaderBgLft"><!--spacer--></td>  
             <td nowrap="" class="innerBoxHeaderBgRpt"><h2>测试情况</h2></td>
             <!-- Edit Section Header Here -->                 
             <td width="3" class="innerBoxHeaderBgRt"><!--spacer--> 
             </td>               
             </tr>              
              <tr>                  
              <td width="3" class="innerBoxSideLft"><!--spacer-->                 
              </td>                 
              <td class="innerBoxContent"><!-- Begin Section Content-->                   
              <!-- Begin Two Column Signpost-->                   
              <table cellspacing="0" cellpadding="0" border="0" width="100%" padding="0" class="innerPgSignpost">   
              <tbody>              
              <tr>                    
               <td valign="top">
               <p><strong>MySQL5.4 -高达90 ％的快速查询响应时间和16路x86服务器和64路CMT服务器的可扩展性</strong></p>
				<p>　　MySQL5.4包含了性能和可扩展性方面的改进，使InnoDB存储引擎可以扩展到使用16路x86服务器和64路CMT服务器。 
				MySQL的5.4还包含了新的子查询优化方法，并针对JOIN操作作了改进，对一些特定的查询，可以提高90 ％的快速查询响应时间。这些性能和可扩展性是透明的，不需要任何额外的应用程序编码或是SQL编码。启用批量关键字存取请求，只需要改变一个配置。如需关于基准测试和MySQL 5.4新功能的详细资料，请访问以下链接：</p>
				<ul>
					<li><a href="http://blogs.sun.com/allanp/entry/mysql_5_4_scalability_on" target="_blank">MySQL5.4在CMT上的扩展性</a></li>
					<li><a href="http://mikaelronstrom.blogspot.com/2009/04/mysql-54-scaling-to-16-way-x86-and-64.html" target="_blank">MySQL5.4 SysBench的性能测试</a></li>
					<li><a href="http://dev.mysql.com/tech-resources/articles/mysql-54.html" target="_blank">快速浏览MySQL5.4</a></li>
				</ul>
				<p><strong>MySQL/SUN 关于SPECJ 基准测试创造的世界记录</strong></p>
				<p>　　在两台Sun Fire X4150服务器上都运行MySQL ， OpenSolaris和GlassFish应用服务器，针对SPECjAppServer2004基准测试，得到了最好的开源测试结果，该结果于08年11月6日成为官方测试结果。测试内容为，在两台Sun Fire X4150服务器，同等配备一个英特尔至强处理器，使用1197.10的SPECjAppServer2004 JOPS @标准，得到了最佳的开源测试结果。在使用SPECjAppServer2004基准测试的历史上，MySQL ，OpenSolaris,GlassFish与 Sun Fire X4150服务器相结合工作效能是最佳的。在SPECjAppServer2004基准测试的结果中，使用Sun的解决方案是价格最低的。MySQL / Sun公司的解决方案比其他竞争对手的解决方案在价格上具有超出53倍的优势。</p>
				<p>如需详细的测试结果，请访问以下链接：</p>
				<ul>
					<li><a href="http://www.sun.com/servers/x64/x4150/benchmarks.jsp" target="_blank">Sun Fire X4150 Server - Benchmarks</a></li>
					<li><a href="http://blogs.sun.com/tomdaly/entry/sun_compelling_price_performance" target="_blank">Sun Demonstrates Compelling Price Performance : Tom Daly's Weblog</a></li>
					<li><a href="http://blogs.sun.com/bmseer/entry/opensolaris_specjappserver_sun_fire_x4150" target="_blank">OpenSolaris SPECjAppServer Sun Fire X4150</a></li>
				</ul>
				<p>　　MySQL数据库在性能，吞吐量和可扩展性方面始终表现都是最好的。所以，MySQL被应用于一些最苛刻的，高容量，关键业务应用的公司，就毫不奇怪了。如美联社， Cox Communications公司，谷歌，德国汉莎航空公司，美国麻省理工学院林肯实验室，美国航天局， Sabre控股公司，雅虎等等。这些公司运行着大规模“扩展”的 Web和数据仓库应用程序，MySQL正运行在几十，几百甚至成千上万的廉价的英特尔和Opteron服务器上，这一做法节省了数百万美元花费。 MySQL可以扩展至，能够处理数十亿行和TB级的数据，用于范围广泛的事务和分析应用。 </p>
				<p>获得MySQL的性能基准白皮书：</p>
				<p><a href="http://www.mysql.com/it-resources/white-papers/performance.php" target="_blank">Get the MySQL Performance Benchmarks white paper</a></p>
               </td>                       
                  </tr>                     
                  </tbody>                   
                  </table>                   
                  <!-- End Three Column Signpost-->                   <!-- End Section Content-->
                  </td>                 
                  <td width="3" class="innerBoxSideRt"><!--spacer--></td>               
                  </tr>               
                  <tr>                  
                  <td class="innerBoxBgLftBot">
                  <img height="1" width="3" src="../../assets/spacer.gif" alt="" />
                  </td>                 
                  <td nowrap="" class="innerBoxBgRptBot"><!--spacer--></td>                 
                  <td width="3" class="innerBoxBgRtBot"><img height="1" width="3" src="../../assets/spacer.gif" alt="" /></td>
              </tr>             
              </tbody>           
              </table> 
              <div class="backToTop"><a href="#top" class="backToTop">回到页首</a></div><br/> 
            
            <!-- End Anchor Link Section --> 		 		<!-- Begin Acquired Products Signpost Section -->
            <table cellspacing="0" cellpadding="0" border="0" width="100%" padding="0" class="fifteenpxBotMargin">
             <tbody>               
             <tr>                  
             <td width="3" class="innerBoxHeaderBgLft"><!--spacer--></td>  
             <td nowrap="" class="innerBoxHeaderBgRpt"><h2>Cluster性能测试</h2></td>
             <!-- Edit Section Header Here -->                 
             <td width="3" class="innerBoxHeaderBgRt"><!--spacer--> 
             </td>               
             </tr>              
              <tr>                  
              <td width="3" class="innerBoxSideLft"><!--spacer-->                 
              </td>                 
              <td class="innerBoxContent"><!-- Begin Section Content-->                   
              <!-- Begin Two Column Signpost-->                   
              <table cellspacing="0" cellpadding="0" border="0" width="100%" padding="0" class="innerPgSignpost">   
              <tbody>              
              <tr>                    
               <td valign="top">
               <p><strong>MySQL Cluster 7.0 now scales linearly in two dimensions with more than 4 times more transactional throughput!</strong></p>
				<p>　　提供较高的SLA承诺的主机托管服务商需要克服很多运维困难，其中就包括数据库的高可用性，可扩展性和技能高的服务人员，MySQL能极大的改善主机托管服务商在数据库运维管理上的能力。</p>
				<p>　　随着MySQL Cluster 7.0的发布，数据节点现在可以是多线程的。在MySQL Cluster 6.3中每个线程是不会和其它的线程竞争的。现在在7.0中，2个节点的集群性能在6.3中需要10个节点才能达到。一个数据节点可以使用MySQL服务器中24个核。现在，cluster7.04.6X多的DBT2事务处理能力。</p>
				<p>更多详细信息，请访问如下链接:</p>
				<ul>
					<li><a href="http://blogs.sun.com/hasham/entry/mysql_cluster_7_performance_benchmark" target="_blank">MySQL Cluster 7 DBT2 Performance Benchmark, Configurations and Results</a></li>
					<li><a href="http://mikaelronstrom.blogspot.com/2009/04/mysql-cluster-70-scales-linearly-in-two.html" target="_blank">MySQL Cluster 7.0 DBT2 Benchmarks</a></li>
				</ul>
				<p><strong>Performance Impacts of On-Line Add Node Operations</strong></p>
				<p>　　MySQL Cluster 7.0支持在线添加节点，而不影响应用或是用户对集群的访问。以下是测试在线添加节点的时候，吞吐量和延迟的影响。</p>
				<ul>
					<li><a href="http://johanandersson.blogspot.com/2009/03/online-add-node-preliminary-numbers.html" target="_blank">On-line add node performance tests, part 1</a></li>
					<li><a href="http://johanandersson.blogspot.com/2009/03/online-add-node-preliminary-numbers-2.html" target="_blank">On-line add node performance tests, part 2</a></li>
				</ul>
               </td>                       
                  </tr>                     
                  </tbody>                   
                  </table>                   
                  <!-- End Three Column Signpost-->                   <!-- End Section Content-->
                  </td>                 
                  <td width="3" class="innerBoxSideRt"><!--spacer--></td>               
                  </tr>               
                  <tr>                  
                  <td class="innerBoxBgLftBot">
                  <img height="1" width="3" src="../../assets/spacer.gif" alt="" />
                  </td>                 
                  <td nowrap="" class="innerBoxBgRptBot"><!--spacer--></td>                 
                  <td width="3" class="innerBoxBgRtBot"><img height="1" width="3" src="../../assets/spacer.gif" alt="" /></td>
              </tr>             
              </tbody>           
              </table> 
      		  <div class="backToTop"><a href="#top" class="backToTop">回到页首</a></div>
       		<!-- End Split Box -->           <!-- Begin Content Management Signpost Section -->     
        
              <!-- End Content Management Signpost Section --></td>       
              <td width="11"><img height="1" width="11" src="../../assets/spacer.gif" alt="" /></td>
         	</tr>   
         	</tbody>
         	</table>
         </div>

  

<div id="Wrapper_FixedWidth_Rightnav">

<div style="background-color:#FFFFFF;">

    

                                      

       <div class="contactboxTop"><!--spacer--></div> 
<div class="contactboxMiddle"> 
<div class="paddingTen"> 
<div class="phonenumber"><b>销售热线<br /> 400-820-6580</b>
<!--&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;13916131869</b>--></div>
<div class="icons"><a href=""><img height="16" width="16" alt="爱可生联系方式" src="../../assets/contact_box_phone.gif" /></a>
<a href="">爱可生联系方式</a></div>
</div> 
</div> 
<div class="contactboxBottom"><!--spacer--></div> 
       <!-- Banner start -->


    		<div class="expandall"><a title="Expand All" href="javascript:expandAll();" >展开所有</a> | <a title="Close All" href="javascript:closeAll();" >隐藏所有</a></div>    		

    		
    		
    		
		   <div class="sidebox">
		
		   	<h4><a href="javascript:toggleSidebox('sidebody1');" class="rhstoggle">白皮书</a></h4>                 
		
				
		
		     	<div id="sidebody1" class="contents"> 
		     	<ul class="sidelist">
					<img src="../../assets/adobe.jpg"/><A href="../../download.jsp?f=A1012.pdf" target=_blank>MySQL高可用架构技术</A><SPAN class=legalese>(PDF)</SPAN><br/>
					<img src="../../assets/adobe.jpg"/><A href="../../download.jsp?f=A1020.pdf" target=_blank>MySQL_vs_Oracle性能优化</A><SPAN class=legalese>(PDF)</SPAN><br/>
				</ul> 
		
		        	<div class="close"><a class="close" href="javascript:toggleSidebox('sidebody1');">隐藏</a></div>
		
		     	</div>
		
		     	<div class="sideboxbottom"><!-- Spacer --></div>
		
			</div>
		
			<script>
		
					DisplayElements(getElementsByPrefix('sidebody',document.documentElement));
		
					DisplayRightNav();
		
			</script> 
    		
    		
    		
    		
    		
    		
	<div class="sidebox">
   	<h4><a href="javascript:toggleSidebox('sidebody2');" class="rhstoggle">MySQL企业版5.5</a></h4>                 
		
     	<div id="sidebody2" class="contents">     	     
        	  <img alt="mysql enterprise 5.5" src="../../assets/steady.jpg">
	
        	<div class="close"><a class="close" href="javascript:toggleSidebox('sidebody2');">隐藏</a></div>
     	</div>

     	<div class="sideboxbottom"><!-- Spacer --></div>
	</div>
    	
  

  			<script>
		
					DisplayElements(getElementsByPrefix('sidebody',document.documentElement));
		
					DisplayRightNav();
		
			</script> 

	                  



</div>

</div>

<!--Contribution Region Ends Here --><!--End of Center Content--><!--RIGHT NAV START--><!--coming from Region definition --><!--RIGHT NAV END-->



	<!-- ****************************************************** -->
	<c:import url="../../template/footer.jsp"></c:import>
	<!-- ****************************************************** -->
</body>
</html>